﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="karta.aspx.cs" Inherits="STS.Pacjent.karta" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <asp:Label ID="id_pacjenta" runat="server" Text="Label" Visible="False"></asp:Label>
<asp:Label ID="tekst" runat="server" Text="Label" Visible="False"></asp:Label>
<asp:Panel ID="Panel1" runat="server">
    Kreatynina:<br />
    <asp:Chart ID="Chart1" runat="server" DataSourceID="SqlDataSource1" 
        Palette="Excel">
        <Series>
            <asp:Series Name="Series1" ChartType="Line" XValueMember="data_badania" 
                YValueMembers="kreatynina">
            </asp:Series>
        </Series>
        <ChartAreas>
            <asp:ChartArea Name="ChartArea1">
            </asp:ChartArea>
        </ChartAreas>
    </asp:Chart>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:MGRConnectionString %>" 
        SelectCommand="SELECT [kreatynina], [data_badania] FROM [badania_krew] WHERE ([id_pacjenta] = @id_pacjenta)">
        <SelectParameters>
            <asp:ControlParameter ControlID="id_pacjenta" Name="id_pacjenta" 
                PropertyName="Text" Type="Int32" />
        </SelectParameters>
    </asp:SqlDataSource>
    <br />
    Waga:<br />
    <asp:Chart ID="Chart2" runat="server" DataSourceID="SqlDataSource2">
        <Series>
            <asp:Series Name="Series1" ChartType="Line" XValueMember="waga" 
                YValueMembers="data">
            </asp:Series>
        </Series>
        <ChartAreas>
            <asp:ChartArea Name="ChartArea1">
            </asp:ChartArea>
        </ChartAreas>
    </asp:Chart>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
        ConnectionString="<%$ ConnectionStrings:MGRConnectionString %>" 
        SelectCommand="SELECT [waga], [data] FROM [wizyta] WHERE ([id_pacjenta] = @id_pacjenta)">
        <SelectParameters>
            <asp:ControlParameter ControlID="id_pacjenta" Name="id_pacjenta" 
                PropertyName="Text" Type="Int32" />
        </SelectParameters>
    </asp:SqlDataSource>
    <br />
</asp:Panel>
</asp:Content>
